Microsoft Access Level 3

Outcomes

Participants will learn how to use parameter and action queries, use macros to automate and streamline an Access database and use Access in conjunction with the Internet and other windows based applications.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1 and 2, or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Designing parameter and action queries Creating parameter queries Creating action queries Outer join and crosstab query techniques Joining tables and working with join properties Crosstab queries Editing limitations in query datasheets Form design enhancements Building a form based on joined tables; using functions in forms Using option groups and additional form design enhancements Using command buttons and macros with forms Creating macros and command buttons Using macros to control form properties

Using macros to provide user interaction and automate tasks Using macros to provide user interaction Using macros to automate tasks Advanced report techniques Hiding duplicate data, grouping data, and using functions in reports Introduction to the Internet Using hyperlinks Appendices Replicating databases Using Access with other applications